Oracle Database Creation and Setup

When setting up an Oracle data source, review "Database Creation and Setup" in AssetWise Implementation Guide.

The following permissions are necessary for the newly-created Oracle user:

Note: "NEW_USER" represents the user to which you will install the AssetWise schema, and is provided for example, only.

GRANT CONNECT TO NEW_USER with ADMIN OPTION; 
	  / 
	  GRANT RESOURCE TO NEW_USER with ADMIN OPTION; 
	  / 
	  GRANT CREATE ANY VIEW TO NEW_USER with ADMIN OPTION; 
	  / 
	  GRANT CREATE ANY SEQUENCE TO NEW_USER with ADMIN OPTION; 
	  / 
	  GRANT EXECUTE ON CTXSYS.CTX_DDL TO NEW_USER; 
	  /

Note: These settings above might slightly contradict what is stated in the AssetWise Implementation Guide, yet they are required.